<%@ page import="java.util.List" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.DriverManager" %><%--
  Created by IntelliJ IDEA.
  User: Administrator
  Date: 2018/4/3
  Time: 15:56
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>用户列表</title>
</head>
<body>

<%@ include file="isLogin.jsp"%>
<%--<jsp:include page="isLogin.jsp" />--%>

<style type="text/css">
    table {
        border-collapse: collapse;
    }

    td {
        border:1px solid #000000;
        padding: 10px;
    }

    a {
        text-decoration:none;
    }
</style>

<h1>用户列表</h1>
<table>

   <a href='userAdd.jsp'>添加用户</a>

    <tr>
        <td>用户</td>
        <td>编号</td>
        <td>密码</td>
        <td>编辑信息</td>
        <td>删除信息</td>
    </tr>

    <%



        class User{
            int id;
            String username;
            String password;
        }

        List<User> userList = new ArrayList<User>();

        //从数据库读取数据并存放在userList中
        //3+1

        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet = null;

        String sql = "select * from t_users";

        Class.forName("com.mysql.jdbc.Driver");

        connection = DriverManager.getConnection(
                //serverTimezone=UTC:加载驱动实驱
                "jdbc:mysql://localhost:3306/sctu_javaweb_2018?serverTimezone=UTC",
                "root",
                "123456"
        );


        statement = connection.createStatement();

        resultSet = statement.executeQuery(sql);

        while (resultSet.next()){

            int id = resultSet.getInt(1);
            String username = resultSet.getString(2);
            String password = resultSet.getString(3);

            //面向对象三个特征：封装，继承，多态

            User user = new User();
            user.id = id;
            user.username = username;
            user.password = password;

            userList.add(user);
        }

        resultSet.close();
        statement.close();
        connection.close();


//
//        User chen = new User();
//        chen.id = 1;
//        chen.username = "hexin";
//        chen.password = "123456";
//        userList.add(chen);
//
//        User john = new User();
//        john.id = 2;
//        john.username = "john";
//        john.password = "jdfskdj";
//        userList.add(john);

        for (User user : userList){

            //221替换原则
            out.write("<tr><td>"+user.id+"</td>" +
                    "<td>"+user.username+"</td>" +
                    "<td>"+user.password+"</td>" +
                    "<td><a href='updateUser.jsp?id="+user.id+"" +
                    "&username="+user.username+"" +
                    "&password="+user.password+"'>更新</a></td>" +
                    "<td><a href='deleteUserHandler.jsp?id="+user.id+"'>删除</a></td>");
        }


    %>


    <%--<tr><td>1</td><td>john</td><td>123456</td></tr>--%>

    <%--<tr>--%>

    <%--<td>1</td>--%>
    <%--<td>chen</td>--%>
    <%--<td>123456</td>--%>
    <%--</tr>--%>

</table>

<%--include指令与动作元素--%>
<%--
区别：
    1.

--%>

<%--<%@ include file="footer.jsp" %>--%>

<jsp:include page="footer.jsp">
    <jsp:param name="year" value="2018" />
</jsp:include>

</body>
</html>